package com.aliyun.heiyu.powermaster.server.rotary.contants;

public interface RecommendTempSqlContant {
    String ADD_RECOMMEND = "insert into d_recommend_temp(recommend_temp,current_temp,air_id,collect_time) values(?,?,?,?)";

    String QUERY_RECOMMEND_ID = "SELECT * FROM d_recommend_temp WHERE 1= ? and id = ?";

    String QUERY_RECOMMEND_NEW = "SELECT * FROM d_recommend_temp  ORDER BY id DESC LIMIT 1";

    String QUERY_RECOMMENDS = "SELECT * FROM d_recommend_temp where collect_time > ？ AND collect_time <？";

    String QUERY_RECOMMENDS_HOUR = "SELECT * FROM d_recommend_temp WHERE collect_time > DATE_SUB(NOW(),INTERVAL  30 MINUTE)";

}
